﻿using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MesGLApp.DAL.MesDB
{
    /// <summary>
    /// 异常工单处理记录表
    /// </summary>
    [SugarTable("abnormal_detail")]

    public class ProdAbnormal_Detail
    {
        ///// <summary>
        ///// 主键ID
        ///// </summary>

        //public int id { get; set; }
        /// <summary>
        /// 工单ID
        /// </summary>
        public int prod_id { get; set; }
        /// <summary>
        /// 工单号
        /// </summary>
        public string prod_number { get; set; }
        /// <summary>
        /// 站点ID
        /// </summary>
        public int site_id { get; set; }
        /// <summary>
        /// 站点名称
        /// </summary>
        public string site_name { get; set; }
        /// <summary>
        /// 异常ID
        /// </summary>
        public int status_id { get; set; }
        /// <summary>
        /// 异常名称
        /// </summary>
        public string status_name { get; set; }
        /// <summary>
        /// 异常数量
        /// </summary>
        public decimal abnormal_qty { get; set; }
        /// <summary>
        /// 异常原因ID
        /// 关联表repair_reason的ID
        /// </summary>
        public int reason_id { get; set; }
        /// <summary>
        /// 异常原因名称
        /// </summary>
        public string reason_name { get; set; }
        /// <summary>
        /// 原因备注
        /// </summary>
        public string remark { get; set; }
        /// <summary>
        /// 异常开始时间
        /// </summary>
        public DateTime? begin_time { get; set; }
        /// <summary>
        /// 异常结束时间
        /// </summary>
        public DateTime? end_time { get; set; }
        /// <summary>
        /// 创建人
        /// </summary>
        public string create_user { get; set; }
        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime? create_date { get; set; }
        /// <summary>
        /// 修改人
        /// </summary>
        public string update_user { get; set; }
        /// <summary>
        /// 修改时间
        /// </summary>
        public DateTime? update_date { get; set; }
    }
}
